using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VAKSHSYS
    {
        public DataRow Convert2AKSHSYS(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryAKSHSYS(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["AKYMANDANT"] = " ".PadRight(2 ); 
         dwReturn["AKYSYS"] = " ".PadRight(2 ); 
         dwReturn["AKYJJJJ"] = " ".PadRight(4 ); 
         dwReturn["AKYMM"] = " ".PadRight(2 ); 
         dwReturn["AKYAENZL"] = " ".PadRight(0 ); 
         dwReturn["AKYAENB"] = " ".PadRight(8 ); 
         dwReturn["AKYAEND"] = " ".PadRight(0 ); 
         dwReturn["AKYNEUB"] = " ".PadRight(8 ); 
         dwReturn["AKYNEUD"] = " ".PadRight(0 ); 
         dwReturn["AKYSHNRE"] = " ".PadRight(1 ); 
         dwReturn["AKYSHNRM"] = " ".PadRight(1 ); 
         dwReturn["AKYSHNRL"] = " ".PadRight(1 ); 
         dwReturn["AKYSHNRN"] = " ".PadRight(1 ); 
         dwReturn["AKYSHTYPE1"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM1"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL1"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN1"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER11"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE2"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM2"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL2"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN2"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER12"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE3"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM3"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL3"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN3"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER13"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE4"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM4"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL4"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN4"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER14"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE5"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM5"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL5"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN5"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER15"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE6"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM6"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL6"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN6"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER16"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE7"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM7"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL7"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN7"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER17"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE8"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM8"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL8"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN8"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER18"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE9"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM9"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL9"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN9"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER19"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE10"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM10"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL10"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN10"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER110"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE11"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM11"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL11"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN11"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER111"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE12"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM12"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL12"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN12"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER112"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE13"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM13"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL13"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN13"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER113"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE14"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM14"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL14"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN14"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER114"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE15"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM15"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL15"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN15"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER115"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE16"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM16"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL16"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN16"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER116"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE17"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM17"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL17"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN17"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER117"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE18"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM18"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL18"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN18"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER118"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE19"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM19"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL19"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN19"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER119"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE20"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM20"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL20"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN20"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER120"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE21"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM21"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL21"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN21"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER121"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE22"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM22"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL22"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN22"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER122"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE23"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM23"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL23"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN23"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER123"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE24"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM24"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL24"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN24"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER124"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE25"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM25"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL25"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN25"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER125"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE26"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM26"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL26"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN26"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER126"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE27"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM27"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL27"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN27"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER127"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE28"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM28"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL28"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN28"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER128"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE29"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM29"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL29"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN29"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER129"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE30"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM30"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL30"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN30"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER130"] = " ".PadRight(8 ); 
         dwReturn["AKYSHTYPE31"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPM31"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPL31"] = " ".PadRight(2 ); 
         dwReturn["AKYSHTYPN31"] = " ".PadRight(2 ); 
         dwReturn["AKYFILLER131"] = " ".PadRight(8 ); 
         dwReturn["AKYFILLER2"] = " ".PadRight(64 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapAKSHSYS(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveAKSHSYS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryAKSHSYS(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapAKSHSYS(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertAKSHSYS(dwLocal, ITXDBVERSION);
            }
            UpdateAKSHSYS(dwLocal);
        }
        public void InsertAKSHSYS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO AKSHSYS(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryAKSHSYS(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM AKSHSYS WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM AKSHSYS  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "AKSHSYS";
            Return = Result;
            return Return;
        }
        public void DeleteAKSHSYS(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM AKSHSYS   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateAKSHSYS(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE AKSHSYS SET "
                    +"AKYMANDANT= :AKYMANDANT,"
                    +"AKYSYS= :AKYSYS,"
                    +"AKYJJJJ= :AKYJJJJ,"
                    +"AKYMM= :AKYMM,"
                    +"AKYAENZL= :AKYAENZL,"
                    +"AKYAENB= :AKYAENB,"
                    +"AKYAEND= :AKYAEND,"
                    +"AKYNEUB= :AKYNEUB,"
                    +"AKYNEUD= :AKYNEUD,"
                    +"AKYSHNRE= :AKYSHNRE,"
                    +"AKYSHNRM= :AKYSHNRM,"
                    +"AKYSHNRL= :AKYSHNRL,"
                    +"AKYSHNRN= :AKYSHNRN,"
                    +"AKYSHTYPE1= :AKYSHTYPE1,"
                    +"AKYSHTYPM1= :AKYSHTYPM1,"
                    +"AKYSHTYPL1= :AKYSHTYPL1,"
                    +"AKYSHTYPN1= :AKYSHTYPN1,"
                    +"AKYFILLER11= :AKYFILLER11,"
                    +"AKYSHTYPE2= :AKYSHTYPE2,"
                    +"AKYSHTYPM2= :AKYSHTYPM2,"
                    +"AKYSHTYPL2= :AKYSHTYPL2,"
                    +"AKYSHTYPN2= :AKYSHTYPN2,"
                    +"AKYFILLER12= :AKYFILLER12,"
                    +"AKYSHTYPE3= :AKYSHTYPE3,"
                    +"AKYSHTYPM3= :AKYSHTYPM3,"
                    +"AKYSHTYPL3= :AKYSHTYPL3,"
                    +"AKYSHTYPN3= :AKYSHTYPN3,"
                    +"AKYFILLER13= :AKYFILLER13,"
                    +"AKYSHTYPE4= :AKYSHTYPE4,"
                    +"AKYSHTYPM4= :AKYSHTYPM4,"
                    +"AKYSHTYPL4= :AKYSHTYPL4,"
                    +"AKYSHTYPN4= :AKYSHTYPN4,"
                    +"AKYFILLER14= :AKYFILLER14,"
                    +"AKYSHTYPE5= :AKYSHTYPE5,"
                    +"AKYSHTYPM5= :AKYSHTYPM5,"
                    +"AKYSHTYPL5= :AKYSHTYPL5,"
                    +"AKYSHTYPN5= :AKYSHTYPN5,"
                    +"AKYFILLER15= :AKYFILLER15,"
                    +"AKYSHTYPE6= :AKYSHTYPE6,"
                    +"AKYSHTYPM6= :AKYSHTYPM6,"
                    +"AKYSHTYPL6= :AKYSHTYPL6,"
                    +"AKYSHTYPN6= :AKYSHTYPN6,"
                    +"AKYFILLER16= :AKYFILLER16,"
                    +"AKYSHTYPE7= :AKYSHTYPE7,"
                    +"AKYSHTYPM7= :AKYSHTYPM7,"
                    +"AKYSHTYPL7= :AKYSHTYPL7,"
                    +"AKYSHTYPN7= :AKYSHTYPN7,"
                    +"AKYFILLER17= :AKYFILLER17,"
                    +"AKYSHTYPE8= :AKYSHTYPE8,"
                    +"AKYSHTYPM8= :AKYSHTYPM8,"
                    +"AKYSHTYPL8= :AKYSHTYPL8,"
                    +"AKYSHTYPN8= :AKYSHTYPN8,"
                    +"AKYFILLER18= :AKYFILLER18,"
                    +"AKYSHTYPE9= :AKYSHTYPE9,"
                    +"AKYSHTYPM9= :AKYSHTYPM9,"
                    +"AKYSHTYPL9= :AKYSHTYPL9,"
                    +"AKYSHTYPN9= :AKYSHTYPN9,"
                    +"AKYFILLER19= :AKYFILLER19,"
                    +"AKYSHTYPE10= :AKYSHTYPE10,"
                    +"AKYSHTYPM10= :AKYSHTYPM10,"
                    +"AKYSHTYPL10= :AKYSHTYPL10,"
                    +"AKYSHTYPN10= :AKYSHTYPN10,"
                    +"AKYFILLER110= :AKYFILLER110,"
                    +"AKYSHTYPE11= :AKYSHTYPE11,"
                    +"AKYSHTYPM11= :AKYSHTYPM11,"
                    +"AKYSHTYPL11= :AKYSHTYPL11,"
                    +"AKYSHTYPN11= :AKYSHTYPN11,"
                    +"AKYFILLER111= :AKYFILLER111,"
                    +"AKYSHTYPE12= :AKYSHTYPE12,"
                    +"AKYSHTYPM12= :AKYSHTYPM12,"
                    +"AKYSHTYPL12= :AKYSHTYPL12,"
                    +"AKYSHTYPN12= :AKYSHTYPN12,"
                    +"AKYFILLER112= :AKYFILLER112,"
                    +"AKYSHTYPE13= :AKYSHTYPE13,"
                    +"AKYSHTYPM13= :AKYSHTYPM13,"
                    +"AKYSHTYPL13= :AKYSHTYPL13,"
                    +"AKYSHTYPN13= :AKYSHTYPN13,"
                    +"AKYFILLER113= :AKYFILLER113,"
                    +"AKYSHTYPE14= :AKYSHTYPE14,"
                    +"AKYSHTYPM14= :AKYSHTYPM14,"
                    +"AKYSHTYPL14= :AKYSHTYPL14,"
                    +"AKYSHTYPN14= :AKYSHTYPN14,"
                    +"AKYFILLER114= :AKYFILLER114,"
                    +"AKYSHTYPE15= :AKYSHTYPE15,"
                    +"AKYSHTYPM15= :AKYSHTYPM15,"
                    +"AKYSHTYPL15= :AKYSHTYPL15,"
                    +"AKYSHTYPN15= :AKYSHTYPN15,"
                    +"AKYFILLER115= :AKYFILLER115,"
                    +"AKYSHTYPE16= :AKYSHTYPE16,"
                    +"AKYSHTYPM16= :AKYSHTYPM16,"
                    +"AKYSHTYPL16= :AKYSHTYPL16,"
                    +"AKYSHTYPN16= :AKYSHTYPN16,"
                    +"AKYFILLER116= :AKYFILLER116,"
                    +"AKYSHTYPE17= :AKYSHTYPE17,"
                    +"AKYSHTYPM17= :AKYSHTYPM17,"
                    +"AKYSHTYPL17= :AKYSHTYPL17,"
                    +"AKYSHTYPN17= :AKYSHTYPN17,"
                    +"AKYFILLER117= :AKYFILLER117,"
                    +"AKYSHTYPE18= :AKYSHTYPE18,"
                    +"AKYSHTYPM18= :AKYSHTYPM18,"
                    +"AKYSHTYPL18= :AKYSHTYPL18,"
                    +"AKYSHTYPN18= :AKYSHTYPN18,"
                    +"AKYFILLER118= :AKYFILLER118,"
                    +"AKYSHTYPE19= :AKYSHTYPE19,"
                    +"AKYSHTYPM19= :AKYSHTYPM19,"
                    +"AKYSHTYPL19= :AKYSHTYPL19,"
                    +"AKYSHTYPN19= :AKYSHTYPN19,"
                    +"AKYFILLER119= :AKYFILLER119,"
                    +"AKYSHTYPE20= :AKYSHTYPE20,"
                    +"AKYSHTYPM20= :AKYSHTYPM20,"
                    +"AKYSHTYPL20= :AKYSHTYPL20,"
                    +"AKYSHTYPN20= :AKYSHTYPN20,"
                    +"AKYFILLER120= :AKYFILLER120,"
                    +"AKYSHTYPE21= :AKYSHTYPE21,"
                    +"AKYSHTYPM21= :AKYSHTYPM21,"
                    +"AKYSHTYPL21= :AKYSHTYPL21,"
                    +"AKYSHTYPN21= :AKYSHTYPN21,"
                    +"AKYFILLER121= :AKYFILLER121,"
                    +"AKYSHTYPE22= :AKYSHTYPE22,"
                    +"AKYSHTYPM22= :AKYSHTYPM22,"
                    +"AKYSHTYPL22= :AKYSHTYPL22,"
                    +"AKYSHTYPN22= :AKYSHTYPN22,"
                    +"AKYFILLER122= :AKYFILLER122,"
                    +"AKYSHTYPE23= :AKYSHTYPE23,"
                    +"AKYSHTYPM23= :AKYSHTYPM23,"
                    +"AKYSHTYPL23= :AKYSHTYPL23,"
                    +"AKYSHTYPN23= :AKYSHTYPN23,"
                    +"AKYFILLER123= :AKYFILLER123,"
                    +"AKYSHTYPE24= :AKYSHTYPE24,"
                    +"AKYSHTYPM24= :AKYSHTYPM24,"
                    +"AKYSHTYPL24= :AKYSHTYPL24,"
                    +"AKYSHTYPN24= :AKYSHTYPN24,"
                    +"AKYFILLER124= :AKYFILLER124,"
                    +"AKYSHTYPE25= :AKYSHTYPE25,"
                    +"AKYSHTYPM25= :AKYSHTYPM25,"
                    +"AKYSHTYPL25= :AKYSHTYPL25,"
                    +"AKYSHTYPN25= :AKYSHTYPN25,"
                    +"AKYFILLER125= :AKYFILLER125,"
                    +"AKYSHTYPE26= :AKYSHTYPE26,"
                    +"AKYSHTYPM26= :AKYSHTYPM26,"
                    +"AKYSHTYPL26= :AKYSHTYPL26,"
                    +"AKYSHTYPN26= :AKYSHTYPN26,"
                    +"AKYFILLER126= :AKYFILLER126,"
                    +"AKYSHTYPE27= :AKYSHTYPE27,"
                    +"AKYSHTYPM27= :AKYSHTYPM27,"
                    +"AKYSHTYPL27= :AKYSHTYPL27,"
                    +"AKYSHTYPN27= :AKYSHTYPN27,"
                    +"AKYFILLER127= :AKYFILLER127,"
                    +"AKYSHTYPE28= :AKYSHTYPE28,"
                    +"AKYSHTYPM28= :AKYSHTYPM28,"
                    +"AKYSHTYPL28= :AKYSHTYPL28,"
                    +"AKYSHTYPN28= :AKYSHTYPN28,"
                    +"AKYFILLER128= :AKYFILLER128,"
                    +"AKYSHTYPE29= :AKYSHTYPE29,"
                    +"AKYSHTYPM29= :AKYSHTYPM29,"
                    +"AKYSHTYPL29= :AKYSHTYPL29,"
                    +"AKYSHTYPN29= :AKYSHTYPN29,"
                    +"AKYFILLER129= :AKYFILLER129,"
                    +"AKYSHTYPE30= :AKYSHTYPE30,"
                    +"AKYSHTYPM30= :AKYSHTYPM30,"
                    +"AKYSHTYPL30= :AKYSHTYPL30,"
                    +"AKYSHTYPN30= :AKYSHTYPN30,"
                    +"AKYFILLER130= :AKYFILLER130,"
                    +"AKYSHTYPE31= :AKYSHTYPE31,"
                    +"AKYSHTYPM31= :AKYSHTYPM31,"
                    +"AKYSHTYPL31= :AKYSHTYPL31,"
                    +"AKYSHTYPN31= :AKYSHTYPN31,"
                    +"AKYFILLER131= :AKYFILLER131,"
                    +"AKYFILLER2= :AKYFILLER2,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("AKYMANDANT", OracleType.NVarChar).Value = dwData["AKYMANDANT"].ToString(); 
          or1.Parameters.Add("AKYSYS", OracleType.NVarChar).Value = dwData["AKYSYS"].ToString(); 
          or1.Parameters.Add("AKYJJJJ", OracleType.NVarChar).Value = dwData["AKYJJJJ"].ToString(); 
          or1.Parameters.Add("AKYMM", OracleType.NVarChar).Value = dwData["AKYMM"].ToString(); 
          or1.Parameters.Add("AKYAENZL", OracleType.NVarChar).Value = dwData["AKYAENZL"].ToString(); 
          or1.Parameters.Add("AKYAENB", OracleType.NVarChar).Value = dwData["AKYAENB"].ToString(); 
          or1.Parameters.Add("AKYAEND", OracleType.NVarChar).Value = dwData["AKYAEND"].ToString(); 
          or1.Parameters.Add("AKYNEUB", OracleType.NVarChar).Value = dwData["AKYNEUB"].ToString(); 
          or1.Parameters.Add("AKYNEUD", OracleType.NVarChar).Value = dwData["AKYNEUD"].ToString(); 
          or1.Parameters.Add("AKYSHNRE", OracleType.NVarChar).Value = dwData["AKYSHNRE"].ToString(); 
          or1.Parameters.Add("AKYSHNRM", OracleType.NVarChar).Value = dwData["AKYSHNRM"].ToString(); 
          or1.Parameters.Add("AKYSHNRL", OracleType.NVarChar).Value = dwData["AKYSHNRL"].ToString(); 
          or1.Parameters.Add("AKYSHNRN", OracleType.NVarChar).Value = dwData["AKYSHNRN"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE1", OracleType.NVarChar).Value = dwData["AKYSHTYPE1"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM1", OracleType.NVarChar).Value = dwData["AKYSHTYPM1"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL1", OracleType.NVarChar).Value = dwData["AKYSHTYPL1"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN1", OracleType.NVarChar).Value = dwData["AKYSHTYPN1"].ToString(); 
          or1.Parameters.Add("AKYFILLER11", OracleType.NVarChar).Value = dwData["AKYFILLER11"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE2", OracleType.NVarChar).Value = dwData["AKYSHTYPE2"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM2", OracleType.NVarChar).Value = dwData["AKYSHTYPM2"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL2", OracleType.NVarChar).Value = dwData["AKYSHTYPL2"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN2", OracleType.NVarChar).Value = dwData["AKYSHTYPN2"].ToString(); 
          or1.Parameters.Add("AKYFILLER12", OracleType.NVarChar).Value = dwData["AKYFILLER12"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE3", OracleType.NVarChar).Value = dwData["AKYSHTYPE3"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM3", OracleType.NVarChar).Value = dwData["AKYSHTYPM3"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL3", OracleType.NVarChar).Value = dwData["AKYSHTYPL3"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN3", OracleType.NVarChar).Value = dwData["AKYSHTYPN3"].ToString(); 
          or1.Parameters.Add("AKYFILLER13", OracleType.NVarChar).Value = dwData["AKYFILLER13"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE4", OracleType.NVarChar).Value = dwData["AKYSHTYPE4"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM4", OracleType.NVarChar).Value = dwData["AKYSHTYPM4"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL4", OracleType.NVarChar).Value = dwData["AKYSHTYPL4"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN4", OracleType.NVarChar).Value = dwData["AKYSHTYPN4"].ToString(); 
          or1.Parameters.Add("AKYFILLER14", OracleType.NVarChar).Value = dwData["AKYFILLER14"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE5", OracleType.NVarChar).Value = dwData["AKYSHTYPE5"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM5", OracleType.NVarChar).Value = dwData["AKYSHTYPM5"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL5", OracleType.NVarChar).Value = dwData["AKYSHTYPL5"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN5", OracleType.NVarChar).Value = dwData["AKYSHTYPN5"].ToString(); 
          or1.Parameters.Add("AKYFILLER15", OracleType.NVarChar).Value = dwData["AKYFILLER15"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE6", OracleType.NVarChar).Value = dwData["AKYSHTYPE6"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM6", OracleType.NVarChar).Value = dwData["AKYSHTYPM6"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL6", OracleType.NVarChar).Value = dwData["AKYSHTYPL6"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN6", OracleType.NVarChar).Value = dwData["AKYSHTYPN6"].ToString(); 
          or1.Parameters.Add("AKYFILLER16", OracleType.NVarChar).Value = dwData["AKYFILLER16"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE7", OracleType.NVarChar).Value = dwData["AKYSHTYPE7"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM7", OracleType.NVarChar).Value = dwData["AKYSHTYPM7"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL7", OracleType.NVarChar).Value = dwData["AKYSHTYPL7"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN7", OracleType.NVarChar).Value = dwData["AKYSHTYPN7"].ToString(); 
          or1.Parameters.Add("AKYFILLER17", OracleType.NVarChar).Value = dwData["AKYFILLER17"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE8", OracleType.NVarChar).Value = dwData["AKYSHTYPE8"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM8", OracleType.NVarChar).Value = dwData["AKYSHTYPM8"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL8", OracleType.NVarChar).Value = dwData["AKYSHTYPL8"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN8", OracleType.NVarChar).Value = dwData["AKYSHTYPN8"].ToString(); 
          or1.Parameters.Add("AKYFILLER18", OracleType.NVarChar).Value = dwData["AKYFILLER18"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE9", OracleType.NVarChar).Value = dwData["AKYSHTYPE9"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM9", OracleType.NVarChar).Value = dwData["AKYSHTYPM9"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL9", OracleType.NVarChar).Value = dwData["AKYSHTYPL9"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN9", OracleType.NVarChar).Value = dwData["AKYSHTYPN9"].ToString(); 
          or1.Parameters.Add("AKYFILLER19", OracleType.NVarChar).Value = dwData["AKYFILLER19"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE10", OracleType.NVarChar).Value = dwData["AKYSHTYPE10"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM10", OracleType.NVarChar).Value = dwData["AKYSHTYPM10"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL10", OracleType.NVarChar).Value = dwData["AKYSHTYPL10"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN10", OracleType.NVarChar).Value = dwData["AKYSHTYPN10"].ToString(); 
          or1.Parameters.Add("AKYFILLER110", OracleType.NVarChar).Value = dwData["AKYFILLER110"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE11", OracleType.NVarChar).Value = dwData["AKYSHTYPE11"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM11", OracleType.NVarChar).Value = dwData["AKYSHTYPM11"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL11", OracleType.NVarChar).Value = dwData["AKYSHTYPL11"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN11", OracleType.NVarChar).Value = dwData["AKYSHTYPN11"].ToString(); 
          or1.Parameters.Add("AKYFILLER111", OracleType.NVarChar).Value = dwData["AKYFILLER111"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE12", OracleType.NVarChar).Value = dwData["AKYSHTYPE12"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM12", OracleType.NVarChar).Value = dwData["AKYSHTYPM12"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL12", OracleType.NVarChar).Value = dwData["AKYSHTYPL12"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN12", OracleType.NVarChar).Value = dwData["AKYSHTYPN12"].ToString(); 
          or1.Parameters.Add("AKYFILLER112", OracleType.NVarChar).Value = dwData["AKYFILLER112"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE13", OracleType.NVarChar).Value = dwData["AKYSHTYPE13"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM13", OracleType.NVarChar).Value = dwData["AKYSHTYPM13"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL13", OracleType.NVarChar).Value = dwData["AKYSHTYPL13"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN13", OracleType.NVarChar).Value = dwData["AKYSHTYPN13"].ToString(); 
          or1.Parameters.Add("AKYFILLER113", OracleType.NVarChar).Value = dwData["AKYFILLER113"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE14", OracleType.NVarChar).Value = dwData["AKYSHTYPE14"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM14", OracleType.NVarChar).Value = dwData["AKYSHTYPM14"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL14", OracleType.NVarChar).Value = dwData["AKYSHTYPL14"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN14", OracleType.NVarChar).Value = dwData["AKYSHTYPN14"].ToString(); 
          or1.Parameters.Add("AKYFILLER114", OracleType.NVarChar).Value = dwData["AKYFILLER114"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE15", OracleType.NVarChar).Value = dwData["AKYSHTYPE15"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM15", OracleType.NVarChar).Value = dwData["AKYSHTYPM15"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL15", OracleType.NVarChar).Value = dwData["AKYSHTYPL15"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN15", OracleType.NVarChar).Value = dwData["AKYSHTYPN15"].ToString(); 
          or1.Parameters.Add("AKYFILLER115", OracleType.NVarChar).Value = dwData["AKYFILLER115"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE16", OracleType.NVarChar).Value = dwData["AKYSHTYPE16"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM16", OracleType.NVarChar).Value = dwData["AKYSHTYPM16"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL16", OracleType.NVarChar).Value = dwData["AKYSHTYPL16"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN16", OracleType.NVarChar).Value = dwData["AKYSHTYPN16"].ToString(); 
          or1.Parameters.Add("AKYFILLER116", OracleType.NVarChar).Value = dwData["AKYFILLER116"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE17", OracleType.NVarChar).Value = dwData["AKYSHTYPE17"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM17", OracleType.NVarChar).Value = dwData["AKYSHTYPM17"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL17", OracleType.NVarChar).Value = dwData["AKYSHTYPL17"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN17", OracleType.NVarChar).Value = dwData["AKYSHTYPN17"].ToString(); 
          or1.Parameters.Add("AKYFILLER117", OracleType.NVarChar).Value = dwData["AKYFILLER117"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE18", OracleType.NVarChar).Value = dwData["AKYSHTYPE18"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM18", OracleType.NVarChar).Value = dwData["AKYSHTYPM18"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL18", OracleType.NVarChar).Value = dwData["AKYSHTYPL18"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN18", OracleType.NVarChar).Value = dwData["AKYSHTYPN18"].ToString(); 
          or1.Parameters.Add("AKYFILLER118", OracleType.NVarChar).Value = dwData["AKYFILLER118"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE19", OracleType.NVarChar).Value = dwData["AKYSHTYPE19"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM19", OracleType.NVarChar).Value = dwData["AKYSHTYPM19"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL19", OracleType.NVarChar).Value = dwData["AKYSHTYPL19"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN19", OracleType.NVarChar).Value = dwData["AKYSHTYPN19"].ToString(); 
          or1.Parameters.Add("AKYFILLER119", OracleType.NVarChar).Value = dwData["AKYFILLER119"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE20", OracleType.NVarChar).Value = dwData["AKYSHTYPE20"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM20", OracleType.NVarChar).Value = dwData["AKYSHTYPM20"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL20", OracleType.NVarChar).Value = dwData["AKYSHTYPL20"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN20", OracleType.NVarChar).Value = dwData["AKYSHTYPN20"].ToString(); 
          or1.Parameters.Add("AKYFILLER120", OracleType.NVarChar).Value = dwData["AKYFILLER120"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE21", OracleType.NVarChar).Value = dwData["AKYSHTYPE21"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM21", OracleType.NVarChar).Value = dwData["AKYSHTYPM21"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL21", OracleType.NVarChar).Value = dwData["AKYSHTYPL21"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN21", OracleType.NVarChar).Value = dwData["AKYSHTYPN21"].ToString(); 
          or1.Parameters.Add("AKYFILLER121", OracleType.NVarChar).Value = dwData["AKYFILLER121"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE22", OracleType.NVarChar).Value = dwData["AKYSHTYPE22"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM22", OracleType.NVarChar).Value = dwData["AKYSHTYPM22"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL22", OracleType.NVarChar).Value = dwData["AKYSHTYPL22"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN22", OracleType.NVarChar).Value = dwData["AKYSHTYPN22"].ToString(); 
          or1.Parameters.Add("AKYFILLER122", OracleType.NVarChar).Value = dwData["AKYFILLER122"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE23", OracleType.NVarChar).Value = dwData["AKYSHTYPE23"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM23", OracleType.NVarChar).Value = dwData["AKYSHTYPM23"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL23", OracleType.NVarChar).Value = dwData["AKYSHTYPL23"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN23", OracleType.NVarChar).Value = dwData["AKYSHTYPN23"].ToString(); 
          or1.Parameters.Add("AKYFILLER123", OracleType.NVarChar).Value = dwData["AKYFILLER123"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE24", OracleType.NVarChar).Value = dwData["AKYSHTYPE24"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM24", OracleType.NVarChar).Value = dwData["AKYSHTYPM24"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL24", OracleType.NVarChar).Value = dwData["AKYSHTYPL24"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN24", OracleType.NVarChar).Value = dwData["AKYSHTYPN24"].ToString(); 
          or1.Parameters.Add("AKYFILLER124", OracleType.NVarChar).Value = dwData["AKYFILLER124"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE25", OracleType.NVarChar).Value = dwData["AKYSHTYPE25"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM25", OracleType.NVarChar).Value = dwData["AKYSHTYPM25"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL25", OracleType.NVarChar).Value = dwData["AKYSHTYPL25"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN25", OracleType.NVarChar).Value = dwData["AKYSHTYPN25"].ToString(); 
          or1.Parameters.Add("AKYFILLER125", OracleType.NVarChar).Value = dwData["AKYFILLER125"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE26", OracleType.NVarChar).Value = dwData["AKYSHTYPE26"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM26", OracleType.NVarChar).Value = dwData["AKYSHTYPM26"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL26", OracleType.NVarChar).Value = dwData["AKYSHTYPL26"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN26", OracleType.NVarChar).Value = dwData["AKYSHTYPN26"].ToString(); 
          or1.Parameters.Add("AKYFILLER126", OracleType.NVarChar).Value = dwData["AKYFILLER126"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE27", OracleType.NVarChar).Value = dwData["AKYSHTYPE27"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM27", OracleType.NVarChar).Value = dwData["AKYSHTYPM27"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL27", OracleType.NVarChar).Value = dwData["AKYSHTYPL27"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN27", OracleType.NVarChar).Value = dwData["AKYSHTYPN27"].ToString(); 
          or1.Parameters.Add("AKYFILLER127", OracleType.NVarChar).Value = dwData["AKYFILLER127"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE28", OracleType.NVarChar).Value = dwData["AKYSHTYPE28"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM28", OracleType.NVarChar).Value = dwData["AKYSHTYPM28"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL28", OracleType.NVarChar).Value = dwData["AKYSHTYPL28"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN28", OracleType.NVarChar).Value = dwData["AKYSHTYPN28"].ToString(); 
          or1.Parameters.Add("AKYFILLER128", OracleType.NVarChar).Value = dwData["AKYFILLER128"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE29", OracleType.NVarChar).Value = dwData["AKYSHTYPE29"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM29", OracleType.NVarChar).Value = dwData["AKYSHTYPM29"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL29", OracleType.NVarChar).Value = dwData["AKYSHTYPL29"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN29", OracleType.NVarChar).Value = dwData["AKYSHTYPN29"].ToString(); 
          or1.Parameters.Add("AKYFILLER129", OracleType.NVarChar).Value = dwData["AKYFILLER129"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE30", OracleType.NVarChar).Value = dwData["AKYSHTYPE30"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM30", OracleType.NVarChar).Value = dwData["AKYSHTYPM30"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL30", OracleType.NVarChar).Value = dwData["AKYSHTYPL30"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN30", OracleType.NVarChar).Value = dwData["AKYSHTYPN30"].ToString(); 
          or1.Parameters.Add("AKYFILLER130", OracleType.NVarChar).Value = dwData["AKYFILLER130"].ToString(); 
          or1.Parameters.Add("AKYSHTYPE31", OracleType.NVarChar).Value = dwData["AKYSHTYPE31"].ToString(); 
          or1.Parameters.Add("AKYSHTYPM31", OracleType.NVarChar).Value = dwData["AKYSHTYPM31"].ToString(); 
          or1.Parameters.Add("AKYSHTYPL31", OracleType.NVarChar).Value = dwData["AKYSHTYPL31"].ToString(); 
          or1.Parameters.Add("AKYSHTYPN31", OracleType.NVarChar).Value = dwData["AKYSHTYPN31"].ToString(); 
          or1.Parameters.Add("AKYFILLER131", OracleType.NVarChar).Value = dwData["AKYFILLER131"].ToString(); 
          or1.Parameters.Add("AKYFILLER2", OracleType.NVarChar).Value = dwData["AKYFILLER2"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
